import matplotlib
matplotlib.use('TkAgg')
import  matplotlib.pyplot as plt
import seaborn as sns
import pandas as pd
sns.set_style('darkgrid')

# 中文乱码
# plt.rcParams['font.sans-serif'] = ['SimHei']
plt.rcParams['font.sans-serif'] = ['Heiti TC']
df1 = pd.read_excel('./data/data.xls',sheet_name='sheet2')
sns.barplot(x='学号',y='得分',hue='学科',data=df1)
plt.show()
